package cn.zktr.Personnel.model.mappers.tantiantian;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.omg.CORBA.PERSIST_STORE;

import com.alibaba.fastjson.JSONArray;

import cn.zktr.Personnel.model.pojos.PerEmaFeb;
import cn.zktr.Personnel.model.pojos.PerIntention;
import cn.zktr.Personnel.model.pojos.PerPmsZCls;
//import cn.zktr.Personnel.model.pojos.PerTngItn;
import cn.zktr.Personnel.model.pojos.PerTngPlan;
import cn.zktr.Personnel.model.pojos.PerTngPojs;
import cn.zktr.Personnel.model.pojos.PerTngRet;
import cn.zktr.Personnel.model.pojos.PerTngXes;
import cn.zktr.Personnel.model.uitls.ZhijiEmpVO;
import cn.zktr.Personnel.model.uitls.ZhijiVo;

@Mapper
public interface TngProjectMapper {
	public JSONArray seleProjectYuan();
	public List<ZhijiVo> selezhijiAll();
	public List<ZhijiEmpVO> selezhiEmp(@Param("zhijiid")Integer zhijiid);
	//查询所有培训项目
	public JSONArray selePrAll();
	public PerTngPojs selepojslimt();
	public PerTngPlan seleplanlimt();
//	public PerTngItn seleitnlimt();
	//查询某项目中的员工
	public JSONArray pojs_yuangong(@Param("pojsid")Integer pojsid);
	//查询某项目中的课程
	public JSONArray pojs_kecheng(@Param("pojsid")Integer pojsid);
	public  PerTngXes selexeslimt();
	/**
	 * @param ionid
	 * @returnsele_xiangmu_yixiang根据意向id
	 */
	public PerTngRet sele_xiangmu_yixiang(@Param("ionid")Integer ionid);
	/**
	 * @return查询所有项目结果
	 */
	public JSONArray seleAllxiangmuJieguo();
	
	/**
	 * @param empid
	 * @return查询个人项目结果
	 */
	public JSONArray xiangmuJieguo_Byempid(@Param("empid")Integer empid);
	
	/**
	 * @param empid
	 * @return根据登录员工id查询培训记录
	 */
	public JSONArray gere_peixun(@Param("empid")Integer empid);
	
	/**
	 * 查询所有培训记录
	 */
	public JSONArray peixunjiluAll();
	public JSONArray peixunjiluAll_fanhui();
	/**
	 * @param empname
	 * @return根据登录员工名称查询培训记录
	 */
	public JSONArray peixunjilu_name(@Param("empname")String empname);
	/**
	 * @param empname
	 * @return根据员工名称模糊查询
	 */
	public JSONArray TrainingResulttable_cha(@Param("empname")String empname);
	/**
	 * @param rusid
	 * @return根据课程id查询证书
	 */
	public PerPmsZCls sele_cls_BYrus(@Param("rusid")Integer rusid);
	public PerIntention seleitnlimt();
	
	/**
	 * @param xesid
	 * @return 系统日期到了培训结束日期的后一天修改feb表
	 */
	public PerEmaFeb upde_feb(@Param("xesid")Integer xesid);
	public JSONArray TrainingProjectables_name(@Param("planname")String planname); 
}
